Analise Atendimentos

Dataset statistics

Number of variables	42
Number of observations	16597
Missing cells	60340
Missing cells (%)	8.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.2 MiB
Average record size in memory	329.0 B

Variable types

Numeric	7
Categorical	22
Text	6
Boolean	1
DateTime	4
Unsupported	2

Alerts

`ano_atendimento` has constant value ""	Constant
`fg_ativo` has constant value ""	Constant
`id_orgao` has constant value ""	Constant
`nm_orgao` has constant value ""	Constant
`sg_orgao` has constant value ""	Constant
`nome_familia` has constant value ""	Constant
`status` has constant value ""	Constant
`id_tp_orgao` has constant value ""	Constant
`nu_atendimento` is highly overall correlated with `id_atendimento`	High correlation
`id_atendimento` is highly overall correlated with `nu_atendimento`	High correlation
`id_natureza` is highly overall correlated with `de_natureza`	High correlation
`id_area` is highly overall correlated with `de_area`	High correlation
`id_municipio` is highly overall correlated with `id_municipio_fato_ocorrido` and 1 other fields	High correlation
`id_municipio_fato_ocorrido` is highly overall correlated with `id_municipio`	High correlation
`sg_status_atendimento` is highly overall correlated with `de_status_atendimento`	High correlation
`de_status_atendimento` is highly overall correlated with `sg_status_atendimento`	High correlation
`de_natureza` is highly overall correlated with `id_natureza`	High correlation
`id_programa` is highly overall correlated with `de_programa`	High correlation
`de_programa` is highly overall correlated with `id_programa`	High correlation
`de_area` is highly overall correlated with `id_area` and 2 other fields	High correlation
`id_tp_identificacao` is highly overall correlated with `de_tp_identificacao` and 1 other fields	High correlation
`de_tp_identificacao` is highly overall correlated with `id_tp_identificacao` and 1 other fields	High correlation
`id_forma` is highly overall correlated with `de_area` and 1 other fields	High correlation
`de_forma` is highly overall correlated with `de_area` and 1 other fields	High correlation
`sg_uf` is highly overall correlated with `id_municipio`	High correlation
`de_sexo_solicitante` is highly overall correlated with `id_tp_identificacao` and 2 other fields	High correlation
`de_forma_tratamento` is highly overall correlated with `de_sexo_solicitante`	High correlation
`sg_status_atendimento` is highly imbalanced (81.3%)	Imbalance
`de_status_atendimento` is highly imbalanced (81.3%)	Imbalance
`id_programa` is highly imbalanced (63.7%)	Imbalance
`de_programa` is highly imbalanced (63.7%)	Imbalance
`id_forma` is highly imbalanced (82.9%)	Imbalance
`de_forma` is highly imbalanced (82.9%)	Imbalance
`id_priorizacao` is highly imbalanced (99.9%)	Imbalance
`de_priorizacao` is highly imbalanced (99.9%)	Imbalance
`sg_uf` is highly imbalanced (86.3%)	Imbalance
`id_assunto` has 645 (3.9%) missing values	Missing
`de_assunto` has 645 (3.9%) missing values	Missing
`id_programa` has 645 (3.9%) missing values	Missing
`de_programa` has 645 (3.9%) missing values	Missing
`id_area` has 645 (3.9%) missing values	Missing
`de_area` has 645 (3.9%) missing values	Missing
`id_priorizacao` has 645 (3.9%) missing values	Missing
`de_priorizacao` has 645 (3.9%) missing values	Missing
`de_bairro` has 6964 (42.0%) missing values	Missing
`de_cep` has 6653 (40.1%) missing values	Missing
`de_outro_local` has 16597 (100.0%) missing values	Missing
`de_sexo_solicitante` has 382 (2.3%) missing values	Missing
`nu_idade_solicitante` has 16597 (100.0%) missing values	Missing
`de_forma_tratamento` has 7896 (47.6%) missing values	Missing
`nu_atendimento` has unique values	Unique
`id_atendimento` has unique values	Unique
`ch_atendimento` has unique values	Unique
`de_outro_local` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`nu_idade_solicitante` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-07-06 12:36:56.302239
Analysis finished	2023-07-06 12:37:16.149457
Duration	19.85 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

nu_atendimento
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	16597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9454.6423

Minimum	1
Maximum	18887
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	1
5-th percentile	979.6
Q1	4718
median	9406
Q3	14236
95-th percentile	17964.2
Maximum	18887
Range	18886
Interquartile range (IQR)	9518

Descriptive statistics

Standard deviation	5459.1817
Coefficient of variation (CV)	0.57740753
Kurtosis	-1.2076136
Mean	9454.6423
Median Absolute Deviation (MAD)	4756
Skewness	0.0122141
Sum	1.569187 × 10⁸
Variance	29802664
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
12650	1	< 0.1%
12617	1	< 0.1%
12618	1	< 0.1%
12619	1	< 0.1%
12620	1	< 0.1%
12621	1	< 0.1%
12622	1	< 0.1%
12624	1	< 0.1%
12625	1	< 0.1%
Other values (16587)	16587	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
18887	1	< 0.1%
18886	1	< 0.1%
18885	1	< 0.1%
18884	1	< 0.1%
18883	1	< 0.1%
18882	1	< 0.1%
18881	1	< 0.1%
18880	1	< 0.1%
18879	1	< 0.1%
18878	1	< 0.1%

ano_atendimento
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

2023	16597

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	66388
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2023
2nd row	2023
3rd row	2023
4th row	2023
5th row	2023

Common Values

Value	Count	Frequency (%)
2023	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2023	16597	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	33194	50.0%
0	16597	25.0%
3	16597	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	66388	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	33194	50.0%
0	16597	25.0%
3	16597	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	66388	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	33194	50.0%
0	16597	25.0%
3	16597	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	33194	50.0%
0	16597	25.0%
3	16597	25.0%

id_atendimento
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	16597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	476067.84

Minimum	466499
Maximum	485596
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	466499
5-th percentile	467485.6
Q1	471276
median	476028
Q3	480907
95-th percentile	484663.2
Maximum	485596
Range	19097
Interquartile range (IQR)	9631

Descriptive statistics

Standard deviation	5520.5909
Coefficient of variation (CV)	0.011596227
Kurtosis	-1.2070277
Mean	476067.84
Median Absolute Deviation (MAD)	4811
Skewness	0.0091070718
Sum	7.901298 × 10⁹
Variance	30476924
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
466499	1	< 0.1%
479300	1	< 0.1%
479267	1	< 0.1%
479268	1	< 0.1%
479269	1	< 0.1%
479270	1	< 0.1%
479271	1	< 0.1%
479272	1	< 0.1%
479274	1	< 0.1%
479275	1	< 0.1%
Other values (16587)	16587	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
466499	1	< 0.1%
466500	1	< 0.1%
466502	1	< 0.1%
466503	1	< 0.1%
466504	1	< 0.1%
466505	1	< 0.1%
466506	1	< 0.1%
466507	1	< 0.1%
466508	1	< 0.1%
466509	1	< 0.1%

Value	Count	Frequency (%)
485596	1	< 0.1%
485595	1	< 0.1%
485594	1	< 0.1%
485593	1	< 0.1%
485592	1	< 0.1%
485591	1	< 0.1%
485590	1	< 0.1%
485589	1	< 0.1%
485588	1	< 0.1%
485587	1	< 0.1%

ch_atendimento
Text

UNIQUE

Distinct	16597
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Length

Max length	32
Median length	10
Mean length	10.393686
Min length	10

Characters and Unicode

Total characters	172504
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16597 ?
Unique (%)	100.0%

Sample

1st row	2023000001
2nd row	2023000002
3rd row	2023000004
4th row	2023000005
5th row	2023000006

Value	Count	Frequency (%)
2023000001	1	< 0.1%
2023000072	1	< 0.1%
2023000018	1	< 0.1%
2023000004	1	< 0.1%
2023000005	1	< 0.1%
2023000006	1	< 0.1%
2023000007	1	< 0.1%
2023000008	1	< 0.1%
2023000009	1	< 0.1%
2023000010	1	< 0.1%
Other values (16587)	16587	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	50511	29.3%
2	40200	23.3%
3	23619	13.7%
1	14487	8.4%
6	7035	4.1%
5	6973	4.0%
4	6970	4.0%
7	6942	4.0%
8	6187	3.6%
9	6016	3.5%
Other values (6)	3564	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	168940	97.9%
Uppercase Letter	2970	1.7%
Dash Punctuation	594	0.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	50511	29.9%
2	40200	23.8%
3	23619	14.0%
1	14487	8.6%
6	7035	4.2%
5	6973	4.1%
4	6970	4.1%
7	6942	4.1%
8	6187	3.7%
9	6016	3.6%

Uppercase Letter

Value	Count	Frequency (%)
E	594	20.0%
S	594	20.0%
I	594	20.0%
C	594	20.0%
T	594	20.0%

Dash Punctuation

Value	Count	Frequency (%)
-	594	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	169534	98.3%
Latin	2970	1.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	50511	29.8%
2	40200	23.7%
3	23619	13.9%
1	14487	8.5%
6	7035	4.1%
5	6973	4.1%
4	6970	4.1%
7	6942	4.1%
8	6187	3.6%
9	6016	3.5%

Latin

Value	Count	Frequency (%)
E	594	20.0%
S	594	20.0%
I	594	20.0%
C	594	20.0%
T	594	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	172504	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	50511	29.3%
2	40200	23.3%
3	23619	13.7%
1	14487	8.4%
6	7035	4.1%
5	6973	4.0%
4	6970	4.0%
7	6942	4.0%
8	6187	3.6%
9	6016	3.5%
Other values (6)	3564	2.1%

sg_status_atendimento
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

C	15798
E	743
P	56

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	C
5th row	C

Common Values

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c	15798	95.2%
e	743	4.5%
p	56	0.3%

Most occurring characters

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16597	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16597	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

de_status_atendimento
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Concluido	15798
Encaminhado	743
Pendente	56

Length

Max length	11
Median length	9
Mean length	9.0861601
Min length	8

Characters and Unicode

Total characters	150803
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Concluido
2nd row	Concluido
3rd row	Concluido
4th row	Concluido
5th row	Concluido

Common Values

Value	Count	Frequency (%)
Concluido	15798	95.2%
Encaminhado	743	4.5%
Pendente	56	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
concluido	15798	95.2%
encaminhado	743	4.5%
pendente	56	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	32339	21.4%
n	17396	11.5%
d	16597	11.0%
c	16541	11.0%
i	16541	11.0%
C	15798	10.5%
l	15798	10.5%
u	15798	10.5%
a	1486	1.0%
E	743	0.5%
Other values (5)	1766	1.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	134206	89.0%
Uppercase Letter	16597	11.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	32339	24.1%
n	17396	13.0%
d	16597	12.4%
c	16541	12.3%
i	16541	12.3%
l	15798	11.8%
u	15798	11.8%
a	1486	1.1%
m	743	0.6%
h	743	0.6%
Other values (2)	224	0.2%

Uppercase Letter

Value	Count	Frequency (%)
C	15798	95.2%
E	743	4.5%
P	56	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	150803	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	32339	21.4%
n	17396	11.5%
d	16597	11.0%
c	16541	11.0%
i	16541	11.0%
C	15798	10.5%
l	15798	10.5%
u	15798	10.5%
a	1486	1.0%
E	743	0.5%
Other values (5)	1766	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	150803	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	32339	21.4%
n	17396	11.5%
d	16597	11.0%
c	16541	11.0%
i	16541	11.0%
C	15798	10.5%
l	15798	10.5%
u	15798	10.5%
a	1486	1.0%
E	743	0.5%
Other values (5)	1766	1.2%

fg_ativo
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.3 KiB

True	16597

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	16597	100.0%

dt_criacao
Date

Distinct	16583
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Minimum	2023-01-01 03:29:01.614890
Maximum	2023-07-05 23:29:08.467600

Histogram

Histogram with fixed size bins (bins=50)

dt_entrada
Date

Distinct	16504
Distinct (%)	99.8%
Missing	53
Missing (%)	0.3%
Memory size	129.8 KiB

Minimum	2023-01-02 09:09:38
Maximum	2023-07-05 17:36:56

Histogram

Histogram with fixed size bins (bins=50)

dt_alteracao
Date

Distinct	16583
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Minimum	2023-01-01 03:29:01.614890
Maximum	2023-07-05 23:29:08.467600

Histogram

Histogram with fixed size bins (bins=50)

dt_prazo
Date

Distinct	186
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Minimum	2023-01-31 00:00:00
Maximum	2023-08-04 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

id_orgao
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

2	16597

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	16597	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	16597	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16597	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	16597	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	16597	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	16597	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	16597	100.0%

nm_orgao
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Ouvidoria Geral do Estado	16597

Length

Max length	25
Median length	25
Mean length	25
Min length	25

Characters and Unicode

Total characters	414925
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ouvidoria Geral do Estado
2nd row	Ouvidoria Geral do Estado
3rd row	Ouvidoria Geral do Estado
4th row	Ouvidoria Geral do Estado
5th row	Ouvidoria Geral do Estado

Common Values

Value	Count	Frequency (%)
Ouvidoria Geral do Estado	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ouvidoria	16597	25.0%
geral	16597	25.0%
do	16597	25.0%
estado	16597	25.0%

Most occurring characters

Value	Count	Frequency (%)
d	49791	12.0%
o	49791	12.0%
a	49791	12.0%
	49791	12.0%
i	33194	8.0%
r	33194	8.0%
O	16597	4.0%
u	16597	4.0%
v	16597	4.0%
G	16597	4.0%
Other values (5)	82985	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	315343	76.0%
Space Separator	49791	12.0%
Uppercase Letter	49791	12.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	49791	15.8%
o	49791	15.8%
a	49791	15.8%
i	33194	10.5%
r	33194	10.5%
u	16597	5.3%
v	16597	5.3%
e	16597	5.3%
l	16597	5.3%
s	16597	5.3%

Uppercase Letter

Value	Count	Frequency (%)
O	16597	33.3%
G	16597	33.3%
E	16597	33.3%

Space Separator

Value	Count	Frequency (%)
	49791	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	365134	88.0%
Common	49791	12.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	49791	13.6%
o	49791	13.6%
a	49791	13.6%
i	33194	9.1%
r	33194	9.1%
O	16597	4.5%
u	16597	4.5%
v	16597	4.5%
G	16597	4.5%
e	16597	4.5%
Other values (4)	66388	18.2%

Common

Value	Count	Frequency (%)
	49791	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	414925	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	49791	12.0%
o	49791	12.0%
a	49791	12.0%
	49791	12.0%
i	33194	8.0%
r	33194	8.0%
O	16597	4.0%
u	16597	4.0%
v	16597	4.0%
G	16597	4.0%
Other values (5)	82985	20.0%

sg_orgao
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

OGE	16597

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	49791
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OGE
2nd row	OGE
3rd row	OGE
4th row	OGE
5th row	OGE

Common Values

Value	Count	Frequency (%)
OGE	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
oge	16597	100.0%

Most occurring characters

Value	Count	Frequency (%)
O	16597	33.3%
G	16597	33.3%
E	16597	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49791	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	16597	33.3%
G	16597	33.3%
E	16597	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49791	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	16597	33.3%
G	16597	33.3%
E	16597	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49791	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	16597	33.3%
G	16597	33.3%
E	16597	33.3%

nome_familia
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

SC::Ouvidoria Geral do Estado - OGE	16597

Length

Max length	35
Median length	35
Mean length	35
Min length	35

Characters and Unicode

Total characters	580895
Distinct characters	19
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SC::Ouvidoria Geral do Estado - OGE
2nd row	SC::Ouvidoria Geral do Estado - OGE
3rd row	SC::Ouvidoria Geral do Estado - OGE
4th row	SC::Ouvidoria Geral do Estado - OGE
5th row	SC::Ouvidoria Geral do Estado - OGE

Common Values

Value	Count	Frequency (%)
SC::Ouvidoria Geral do Estado - OGE	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sc::ouvidoria	16597	16.7%
geral	16597	16.7%
do	16597	16.7%
estado	16597	16.7%
	16597	16.7%
oge	16597	16.7%

Most occurring characters

Value	Count	Frequency (%)
	82985	14.3%
d	49791	8.6%
o	49791	8.6%
a	49791	8.6%
r	33194	5.7%
:	33194	5.7%
O	33194	5.7%
i	33194	5.7%
E	33194	5.7%
G	33194	5.7%
Other values (9)	149373	25.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	315343	54.3%
Uppercase Letter	132776	22.9%
Space Separator	82985	14.3%
Other Punctuation	33194	5.7%
Dash Punctuation	16597	2.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	49791	15.8%
o	49791	15.8%
a	49791	15.8%
r	33194	10.5%
i	33194	10.5%
l	16597	5.3%
t	16597	5.3%
s	16597	5.3%
e	16597	5.3%
v	16597	5.3%

Uppercase Letter

Value	Count	Frequency (%)
O	33194	25.0%
E	33194	25.0%
G	33194	25.0%
S	16597	12.5%
C	16597	12.5%

Space Separator

Value	Count	Frequency (%)
	82985	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	33194	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16597	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	448119	77.1%
Common	132776	22.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	49791	11.1%
o	49791	11.1%
a	49791	11.1%
r	33194	7.4%
O	33194	7.4%
i	33194	7.4%
E	33194	7.4%
G	33194	7.4%
l	16597	3.7%
t	16597	3.7%
Other values (6)	99582	22.2%

Common

Value	Count	Frequency (%)
	82985	62.5%
:	33194	25.0%
-	16597	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	580895	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	82985	14.3%
d	49791	8.6%
o	49791	8.6%
a	49791	8.6%
r	33194	5.7%
:	33194	5.7%
O	33194	5.7%
i	33194	5.7%
E	33194	5.7%
G	33194	5.7%
Other values (9)	149373	25.7%

status
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

A	16597

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	16597	100.0%

Most occurring characters

Value	Count	Frequency (%)
A	16597	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16597	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	16597	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16597	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	16597	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	16597	100.0%

id_tp_orgao
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

9	16597

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	9
3rd row	9
4th row	9
5th row	9

Common Values

Value	Count	Frequency (%)
9	16597	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	16597	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	16597	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16597	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	16597	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	16597	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	16597	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	16597	100.0%

id_natureza
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.5400976

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	3
Maximum	16
Range	15
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7474039
Coefficient of variation (CV)	0.68792786
Kurtosis	34.905669
Mean	2.5400976
Median Absolute Deviation (MAD)	1
Skewness	5.1372086
Sum	42158
Variance	3.0534204
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	7577	45.7%
2	5350	32.2%
1	3063	18.5%
8	279	1.7%
16	160	1.0%
4	148	0.9%
14	20	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3063	18.5%
2	5350	32.2%
3	7577	45.7%
4	148	0.9%
8	279	1.7%
14	20	0.1%
16	160	1.0%

Value	Count	Frequency (%)
16	160	1.0%
14	20	0.1%
8	279	1.7%
4	148	0.9%
3	7577	45.7%
2	5350	32.2%
1	3063	18.5%

de_natureza
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Solicitação	7577
Reclamação	5350
Denúncia	3063
Elogio	279
Denúncia (Disque 100)	160
Other values (2)	168

Length

Max length	61
Median length	21
Mean length	10.16985
Min length	6

Characters and Unicode

Total characters	168789
Distinct characters	34
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Solicitação
2nd row	Solicitação
3rd row	Reclamação
4th row	Solicitação
5th row	Reclamação

Common Values

Value	Count	Frequency (%)
Solicitação	7577	45.7%
Reclamação	5350	32.2%
Denúncia	3063	18.5%
Elogio	279	1.7%
Denúncia (Disque 100)	160	1.0%
Sugestão	148	0.9%
Solicitação Documentos/Informações/Lei de Acesso à Informação	20	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
solicitação	7597	44.6%
reclamação	5350	31.4%
denúncia	3223	18.9%
elogio	279	1.6%
disque	160	0.9%
100	160	0.9%
sugestão	148	0.9%
documentos/informações/lei	20	0.1%
de	20	0.1%
acesso	20	0.1%
Other values (2)	40	0.2%

Most occurring characters

Value	Count	Frequency (%)
a	21560	12.8%
o	21370	12.7%
i	18876	11.2%
c	16210	9.6%
l	13226	7.8%
ã	13115	7.8%
ç	12987	7.7%
e	8981	5.3%
t	7765	4.6%
S	7745	4.6%
Other values (24)	26954	16.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	150672	89.3%
Uppercase Letter	16857	10.0%
Decimal Number	480	0.3%
Space Separator	420	0.2%
Close Punctuation	160	0.1%
Open Punctuation	160	0.1%
Other Punctuation	40	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	21560	14.3%
o	21370	14.2%
i	18876	12.5%
c	16210	10.8%
l	13226	8.8%
ã	13115	8.7%
ç	12987	8.6%
e	8981	6.0%
t	7765	5.2%
n	6506	4.3%
Other values (11)	10076	6.7%

Uppercase Letter

Value	Count	Frequency (%)
S	7745	45.9%
R	5350	31.7%
D	3403	20.2%
E	279	1.7%
I	40	0.2%
L	20	0.1%
A	20	0.1%

Decimal Number

Value	Count	Frequency (%)
0	320	66.7%
1	160	33.3%

Space Separator

Value	Count	Frequency (%)
	420	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	160	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	160	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	40	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	167529	99.3%
Common	1260	0.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	21560	12.9%
o	21370	12.8%
i	18876	11.3%
c	16210	9.7%
l	13226	7.9%
ã	13115	7.8%
ç	12987	7.8%
e	8981	5.4%
t	7765	4.6%
S	7745	4.6%
Other values (18)	25694	15.3%

Common

Value	Count	Frequency (%)
	420	33.3%
0	320	25.4%
1	160	12.7%
)	160	12.7%
(	160	12.7%
/	40	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	139424	82.6%
None	29365	17.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	21560	15.5%
o	21370	15.3%
i	18876	13.5%
c	16210	11.6%
l	13226	9.5%
e	8981	6.4%
t	7765	5.6%
S	7745	5.6%
n	6506	4.7%
m	5410	3.9%
Other values (19)	11775	8.4%

None

Value	Count	Frequency (%)
ã	13115	44.7%
ç	12987	44.2%
ú	3223	11.0%
õ	20	0.1%
à	20	0.1%

id_assunto
Real number (ℝ)

MISSING

Distinct	390
Distinct (%)	2.4%
Missing	645
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	968.3577

Minimum	2
Maximum	1754
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	2
5-th percentile	115
Q1	261
median	1316
Q3	1497
95-th percentile	1618
Maximum	1754
Range	1752
Interquartile range (IQR)	1236

Descriptive statistics

Standard deviation	617.39909
Coefficient of variation (CV)	0.63757338
Kurtosis	-1.7158954
Mean	968.3577
Median Absolute Deviation (MAD)	295
Skewness	-0.30739412
Sum	15447242
Variance	381181.63
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1611	2210	13.3%
1449	1096	6.6%
117	882	5.3%
115	820	4.9%
242	648	3.9%
1444	487	2.9%
1354	372	2.2%
1308	365	2.2%
503	343	2.1%
1497	294	1.8%
Other values (380)	8435	50.8%
(Missing)	645	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	64	0.4%
18	107	0.6%
19	36	0.2%
21	1	< 0.1%
28	4	< 0.1%
29	14	0.1%
40	2	< 0.1%
46	4	< 0.1%
61	5	< 0.1%
62	3	< 0.1%

Value	Count	Frequency (%)
1754	2	< 0.1%
1753	14	0.1%
1752	1	< 0.1%
1751	1	< 0.1%
1750	1	< 0.1%
1749	1	< 0.1%
1746	3	< 0.1%
1745	1	< 0.1%
1742	1	< 0.1%
1741	1	< 0.1%

de_assunto
Text

MISSING

Distinct	390
Distinct (%)	2.4%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

Length

Max length	60
Median length	50
Mean length	25.377069
Min length	3

Characters and Unicode

Total characters	404815
Distinct characters	72
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	71 ?
Unique (%)	0.4%

Sample

1st row	Não Foi Possível Compreender
2nd row	Não Foi Possível Compreender
3rd row	Manifestação Incompleta (Falta Dados)
4th row	Fiscalização ambiental
5th row	Manifestação Incompleta (Falta Dados)

Value	Count	Frequency (%)
de	3935	7.8%
falta	2600	5.2%
dados	2356	4.7%
manifestação	2226	4.4%
incompleta	2210	4.4%
não	1342	2.7%
do	1212	2.4%
atendimento	1208	2.4%
compreender	1096	2.2%
possível	1096	2.2%
Other values (587)	31014	61.7%

Most occurring characters

Value	Count	Frequency (%)
a	39505	9.8%
o	37757	9.3%
e	35183	8.7%
	34353	8.5%
i	26013	6.4%
s	22840	5.6%
t	22735	5.6%
n	19710	4.9%
r	18410	4.5%
d	16795	4.1%
Other values (62)	131514	32.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	328266	81.1%
Uppercase Letter	35159	8.7%
Space Separator	34353	8.5%
Close Punctuation	2429	0.6%
Open Punctuation	2429	0.6%
Other Punctuation	1184	0.3%
Decimal Number	721	0.2%
Dash Punctuation	274	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	39505	12.0%
o	37757	11.5%
e	35183	10.7%
i	26013	7.9%
s	22840	7.0%
t	22735	6.9%
n	19710	6.0%
r	18410	5.6%
d	16795	5.1%
l	15492	4.7%
Other values (25)	73826	22.5%

Uppercase Letter

Value	Count	Frequency (%)
F	4790	13.6%
C	4761	13.5%
D	4345	12.4%
I	3420	9.7%
M	3143	8.9%
A	3018	8.6%
P	2899	8.2%
N	1630	4.6%
S	1556	4.4%
E	1210	3.4%
Other values (12)	4387	12.5%

Decimal Number

Value	Count	Frequency (%)
2	150	20.8%
1	144	20.0%
0	127	17.6%
3	111	15.4%
8	98	13.6%
9	73	10.1%
7	18	2.5%

Other Punctuation

Value	Count	Frequency (%)
/	616	52.0%
,	493	41.6%
.	73	6.2%
'	2	0.2%

Space Separator

Value	Count	Frequency (%)
	34353	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2429	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2429	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	274	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363425	89.8%
Common	41390	10.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	39505	10.9%
o	37757	10.4%
e	35183	9.7%
i	26013	7.2%
s	22840	6.3%
t	22735	6.3%
n	19710	5.4%
r	18410	5.1%
d	16795	4.6%
l	15492	4.3%
Other values (47)	108985	30.0%

Common

Value	Count	Frequency (%)
	34353	83.0%
)	2429	5.9%
(	2429	5.9%
/	616	1.5%
,	493	1.2%
-	274	0.7%
2	150	0.4%
1	144	0.3%
0	127	0.3%
3	111	0.3%
Other values (5)	264	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	385667	95.3%
None	19148	4.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	39505	10.2%
o	37757	9.8%
e	35183	9.1%
	34353	8.9%
i	26013	6.7%
s	22840	5.9%
t	22735	5.9%
n	19710	5.1%
r	18410	4.8%
d	16795	4.4%
Other values (49)	112366	29.1%

None

Value	Count	Frequency (%)
ã	6377	33.3%
ç	6284	32.8%
ê	1789	9.3%
í	1504	7.9%
á	1097	5.7%
é	862	4.5%
õ	384	2.0%
ú	274	1.4%
à	251	1.3%
â	185	1.0%
Other values (3)	141	0.7%

id_programa
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

4.0	13783
5.0	2167
2.0	2

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	47856
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.0
2nd row	4.0
3rd row	5.0
4th row	4.0
5th row	4.0

Common Values

Value	Count	Frequency (%)
4.0	13783	83.0%
5.0	2167	13.1%
2.0	2	< 0.1%
(Missing)	645	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4.0	13783	86.4%
5.0	2167	13.6%
2.0	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
4	13783	28.8%
5	2167	4.5%
2	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31904	66.7%
Other Punctuation	15952	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15952	50.0%
4	13783	43.2%
5	2167	6.8%
2	2	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	15952	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	47856	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
4	13783	28.8%
5	2167	4.5%
2	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
4	13783	28.8%
5	2167	4.5%
2	2	< 0.1%

de_programa
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

Ouvidoria externa	13783
Ouvidoria interna	2167
Ouvidoria ambiental	2

Length

Max length	19
Median length	17
Mean length	17.000251
Min length	17

Characters and Unicode

Total characters	271188
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ouvidoria externa
2nd row	Ouvidoria externa
3rd row	Ouvidoria interna
4th row	Ouvidoria externa
5th row	Ouvidoria externa

Common Values

Value	Count	Frequency (%)
Ouvidoria externa	13783	83.0%
Ouvidoria interna	2167	13.1%
Ouvidoria ambiental	2	< 0.1%
(Missing)	645	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ouvidoria	15952	50.0%
externa	13783	43.2%
interna	2167	6.8%
ambiental	2	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
i	34073	12.6%
a	31906	11.8%
r	31902	11.8%
e	29735	11.0%
n	18119	6.7%
O	15952	5.9%
u	15952	5.9%
v	15952	5.9%
d	15952	5.9%
o	15952	5.9%
Other values (6)	45693	16.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	239284	88.2%
Uppercase Letter	15952	5.9%
Space Separator	15952	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	34073	14.2%
a	31906	13.3%
r	31902	13.3%
e	29735	12.4%
n	18119	7.6%
u	15952	6.7%
v	15952	6.7%
d	15952	6.7%
o	15952	6.7%
t	15952	6.7%
Other values (4)	13789	5.8%

Uppercase Letter

Value	Count	Frequency (%)
O	15952	100.0%

Space Separator

Value	Count	Frequency (%)
	15952	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	255236	94.1%
Common	15952	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	34073	13.3%
a	31906	12.5%
r	31902	12.5%
e	29735	11.7%
n	18119	7.1%
O	15952	6.2%
u	15952	6.2%
v	15952	6.2%
d	15952	6.2%
o	15952	6.2%
Other values (5)	29741	11.7%

Common

Value	Count	Frequency (%)
	15952	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	271188	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	34073	12.6%
a	31906	11.8%
r	31902	11.8%
e	29735	11.0%
n	18119	6.7%
O	15952	5.9%
u	15952	5.9%
v	15952	5.9%
d	15952	5.9%
o	15952	5.9%
Other values (6)	45693	16.8%

id_area
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	40
Distinct (%)	0.3%
Missing	645
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	103.15628

Minimum	1
Maximum	218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	4
median	126
Q3	170
95-th percentile	205
Maximum	218
Range	217
Interquartile range (IQR)	166

Descriptive statistics

Standard deviation	81.669501
Coefficient of variation (CV)	0.79170653
Kurtosis	-1.6957471
Mean	103.15628
Median Absolute Deviation (MAD)	79
Skewness	-0.17120849
Sum	1645549
Variance	6669.9074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
4	4081	24.6%
155	3347	20.2%
126	1534	9.2%
170	1390	8.4%
205	1111	6.7%
203	1089	6.6%
1	404	2.4%
8	375	2.3%
213	344	2.1%
27	318	1.9%
Other values (30)	1959	11.8%
(Missing)	645	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	404	2.4%
2	173	1.0%
4	4081	24.6%
5	15	0.1%
8	375	2.3%
13	1	< 0.1%
14	1	< 0.1%
17	1	< 0.1%
18	304	1.8%
21	7	< 0.1%

Value	Count	Frequency (%)
218	2	< 0.1%
213	344	2.1%
212	137	0.8%
209	89	0.5%
205	1111	6.7%
203	1089	6.6%
195	271	1.6%
194	21	0.1%
193	2	< 0.1%
170	1390	8.4%

de_area
Categorical

HIGH CORRELATION MISSING

Distinct	40
Distinct (%)	0.3%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

Educação	4081
Segurança Pública	3347
DETRAN	1534
FATMA	1390
Não Aplicável	1111
Other values (35)	4489

Length

Max length	40
Median length	37
Mean length	11.761535
Min length	5

Characters and Unicode

Total characters	187620
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Não Identificável
2nd row	Não Identificável
3rd row	Não Identificável
4th row	FATMA
5th row	Segurança Pública

Common Values

Value	Count	Frequency (%)
Educação	4081	24.6%
Segurança Pública	3347	20.2%
DETRAN	1534	9.2%
FATMA	1390	8.4%
Não Aplicável	1111	6.7%
Não Identificável	1089	6.6%
Saúde	404	2.4%
Agricultura	375	2.3%
Disque 100	344	2.1%
Infraestrutura	318	1.9%
Other values (30)	1959	11.8%
(Missing)	645	3.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
educação	4218	18.0%
pública	3347	14.3%
segurança	3347	14.3%
não	2200	9.4%
detran	1534	6.5%
fatma	1390	5.9%
aplicável	1111	4.7%
identificável	1089	4.6%
administração	477	2.0%
saúde	404	1.7%
Other values (49)	4346	18.5%

Most occurring characters

Value	Count	Frequency (%)
a	18797	10.0%
c	10887	5.8%
i	10434	5.6%
e	10207	5.4%
u	9876	5.3%
o	9382	5.0%
l	8325	4.4%
ç	8093	4.3%
n	7580	4.0%
	7511	4.0%
Other values (42)	86528	46.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	141684	75.5%
Uppercase Letter	37107	19.8%
Space Separator	7511	4.0%
Decimal Number	1032	0.6%
Other Punctuation	285	0.2%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	18797	13.3%
c	10887	7.7%
i	10434	7.4%
e	10207	7.2%
u	9876	7.0%
o	9382	6.6%
l	8325	5.9%
ç	8093	5.7%
n	7580	5.3%
ã	6945	4.9%
Other values (18)	41158	29.0%

Uppercase Letter

Value	Count	Frequency (%)
A	6830	18.4%
E	6182	16.7%
S	4330	11.7%
N	3981	10.7%
P	3791	10.2%
T	2967	8.0%
D	2074	5.6%
F	1596	4.3%
R	1553	4.2%
I	1410	3.8%
Other values (8)	2393	6.4%

Decimal Number

Value	Count	Frequency (%)
0	688	66.7%
1	344	33.3%

Other Punctuation

Value	Count	Frequency (%)
/	246	86.3%
,	39	13.7%

Space Separator

Value	Count	Frequency (%)
	7511	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	178791	95.3%
Common	8829	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	18797	10.5%
c	10887	6.1%
i	10434	5.8%
e	10207	5.7%
u	9876	5.5%
o	9382	5.2%
l	8325	4.7%
ç	8093	4.5%
n	7580	4.2%
ã	6945	3.9%
Other values (36)	78265	43.8%

Common

Value	Count	Frequency (%)
	7511	85.1%
0	688	7.8%
1	344	3.9%
/	246	2.8%
,	39	0.4%
-	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	165900	88.4%
None	21720	11.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	18797	11.3%
c	10887	6.6%
i	10434	6.3%
e	10207	6.2%
u	9876	6.0%
o	9382	5.7%
l	8325	5.0%
n	7580	4.6%
	7511	4.5%
r	6871	4.1%
Other values (35)	66030	39.8%

None

Value	Count	Frequency (%)
ç	8093	37.3%
ã	6945	32.0%
ú	3751	17.3%
á	2465	11.3%
Á	249	1.1%
ô	176	0.8%
ê	41	0.2%

id_tp_identificacao
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

2	7727
1	7479
3	1391

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	2
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

Most occurring characters

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16597	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	16597	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	7727	46.6%
1	7479	45.1%
3	1391	8.4%

de_tp_identificacao
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Identificado	7727
Anônimo	7479
Sigiloso	1391

Length

Max length	12
Median length	8
Mean length	9.4116407
Min length	7

Characters and Unicode

Total characters	156205
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Anônimo
2nd row	Anônimo
3rd row	Identificado
4th row	Anônimo
5th row	Identificado

Common Values

Value	Count	Frequency (%)
Identificado	7727	46.6%
Anônimo	7479	45.1%
Sigiloso	1391	8.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
identificado	7727	46.6%
anônimo	7479	45.1%
sigiloso	1391	8.4%

Most occurring characters

Value	Count	Frequency (%)
i	25715	16.5%
n	22685	14.5%
o	17988	11.5%
d	15454	9.9%
I	7727	4.9%
c	7727	4.9%
a	7727	4.9%
f	7727	4.9%
t	7727	4.9%
e	7727	4.9%
Other values (7)	28001	17.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	139608	89.4%
Uppercase Letter	16597	10.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	25715	18.4%
n	22685	16.2%
o	17988	12.9%
d	15454	11.1%
c	7727	5.5%
a	7727	5.5%
f	7727	5.5%
t	7727	5.5%
e	7727	5.5%
ô	7479	5.4%
Other values (4)	11652	8.3%

Uppercase Letter

Value	Count	Frequency (%)
I	7727	46.6%
A	7479	45.1%
S	1391	8.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	156205	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	25715	16.5%
n	22685	14.5%
o	17988	11.5%
d	15454	9.9%
I	7727	4.9%
c	7727	4.9%
a	7727	4.9%
f	7727	4.9%
t	7727	4.9%
e	7727	4.9%
Other values (7)	28001	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	148726	95.2%
None	7479	4.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	25715	17.3%
n	22685	15.3%
o	17988	12.1%
d	15454	10.4%
I	7727	5.2%
c	7727	5.2%
a	7727	5.2%
f	7727	5.2%
t	7727	5.2%
e	7727	5.2%
Other values (6)	20522	13.8%

None

Value	Count	Frequency (%)
ô	7479	100.0%

id_forma
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

2	15783
4	480
5	291
3	43

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16597
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

Most occurring characters

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16597	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	16597	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16597	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	15783	95.1%
4	480	2.9%
5	291	1.8%
3	43	0.3%

de_forma
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Internet (portal)	15783
Web-mail (email)	480
Telefone	291
Pessoalmente	43

Length

Max length	17
Median length	17
Mean length	16.800325
Min length	8

Characters and Unicode

Total characters	278835
Distinct characters	21
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Internet (portal)
2nd row	Internet (portal)
3rd row	Internet (portal)
4th row	Internet (portal)
5th row	Internet (portal)

Common Values

Value	Count	Frequency (%)
Internet (portal)	15783	95.1%
Web-mail (email)	480	2.9%
Telefone	291	1.8%
Pessoalmente	43	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
internet	15783	48.0%
portal	15783	48.0%
web-mail	480	1.5%
email	480	1.5%
telefone	291	0.9%
pessoalmente	43	0.1%

Most occurring characters

Value	Count	Frequency (%)
t	47392	17.0%
e	33528	12.0%
n	31900	11.4%
r	31566	11.3%
l	17077	6.1%
a	16786	6.0%
	16263	5.8%
(	16263	5.8%
)	16263	5.8%
o	16117	5.8%
Other values (11)	35680	12.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	212969	76.4%
Uppercase Letter	16597	6.0%
Space Separator	16263	5.8%
Open Punctuation	16263	5.8%
Close Punctuation	16263	5.8%
Dash Punctuation	480	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	47392	22.3%
e	33528	15.7%
n	31900	15.0%
r	31566	14.8%
l	17077	8.0%
a	16786	7.9%
o	16117	7.6%
p	15783	7.4%
m	1003	0.5%
i	960	0.5%
Other values (3)	857	0.4%

Uppercase Letter

Value	Count	Frequency (%)
I	15783	95.1%
W	480	2.9%
T	291	1.8%
P	43	0.3%

Space Separator

Value	Count	Frequency (%)
	16263	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	16263	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	16263	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	480	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	229566	82.3%
Common	49269	17.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	47392	20.6%
e	33528	14.6%
n	31900	13.9%
r	31566	13.8%
l	17077	7.4%
a	16786	7.3%
o	16117	7.0%
I	15783	6.9%
p	15783	6.9%
m	1003	0.4%
Other values (7)	2631	1.1%

Common

Value	Count	Frequency (%)
	16263	33.0%
(	16263	33.0%
)	16263	33.0%
-	480	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	278835	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	47392	17.0%
e	33528	12.0%
n	31900	11.4%
r	31566	11.3%
l	17077	6.1%
a	16786	6.0%
	16263	5.8%
(	16263	5.8%
)	16263	5.8%
o	16117	5.8%
Other values (11)	35680	12.8%

id_priorizacao
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

5.0	15951
4.0	1

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	47856
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	15951	96.1%
4.0	1	< 0.1%
(Missing)	645	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	15951	> 99.9%
4.0	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
5	15951	33.3%
4	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	31904	66.7%
Other Punctuation	15952	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	15952	50.0%
5	15951	50.0%
4	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
.	15952	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	47856	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
5	15951	33.3%
4	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47856	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	15952	33.3%
0	15952	33.3%
5	15951	33.3%
4	1	< 0.1%

de_priorizacao
Categorical

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	645
Missing (%)	3.9%
Memory size	129.8 KiB

Normal	15951
Média	1

Length

Max length	6
Median length	6
Mean length	5.9999373
Min length	5

Characters and Unicode

Total characters	95711
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Normal
2nd row	Normal
3rd row	Normal
4th row	Normal
5th row	Normal

Common Values

Value	Count	Frequency (%)
Normal	15951	96.1%
Média	1	< 0.1%
(Missing)	645	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
normal	15951	> 99.9%
média	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	15952	16.7%
N	15951	16.7%
o	15951	16.7%
r	15951	16.7%
m	15951	16.7%
l	15951	16.7%
M	1	< 0.1%
é	1	< 0.1%
d	1	< 0.1%
i	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	79759	83.3%
Uppercase Letter	15952	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	15952	20.0%
o	15951	20.0%
r	15951	20.0%
m	15951	20.0%
l	15951	20.0%
é	1	< 0.1%
d	1	< 0.1%
i	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
N	15951	> 99.9%
M	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	95711	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	15952	16.7%
N	15951	16.7%
o	15951	16.7%
r	15951	16.7%
m	15951	16.7%
l	15951	16.7%
M	1	< 0.1%
é	1	< 0.1%
d	1	< 0.1%
i	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	95710	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	15952	16.7%
N	15951	16.7%
o	15951	16.7%
r	15951	16.7%
m	15951	16.7%
l	15951	16.7%
M	1	< 0.1%
d	1	< 0.1%
i	1	< 0.1%

None

Value	Count	Frequency (%)
é	1	100.0%

id_municipio
Real number (ℝ)

HIGH CORRELATION

Distinct	554
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75300.725

Minimum	27
Maximum	108353
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	27
5-th percentile	71706
Q1	76112
median	76570
Q3	77755
95-th percentile	79227
Maximum	108353
Range	108326
Interquartile range (IQR)	1643

Descriptive statistics

Standard deviation	11146.382
Coefficient of variation (CV)	0.1480249
Kurtosis	21.145228
Mean	75300.725
Median Absolute Deviation (MAD)	702
Skewness	-4.248985
Sum	1.2497661 × 10⁹
Variance	1.2424184 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
76414	2918	17.6%
77127	1015	6.1%
78700	736	4.4%
75680	604	3.6%
77755	516	3.1%
76970	468	2.8%
76066	435	2.6%
15890	384	2.3%
76180	326	2.0%
77178	298	1.8%
Other values (544)	8897	53.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
27	1	< 0.1%
124	1	< 0.1%
809	3	< 0.1%
2054	7	< 0.1%
2542	2	< 0.1%
3719	1	< 0.1%
4006	1	< 0.1%
5339	1	< 0.1%
6084	1	< 0.1%
8974	3	< 0.1%

Value	Count	Frequency (%)
108353	53	0.3%
108352	17	0.1%
108350	2	< 0.1%
108243	1	< 0.1%
107077	3	< 0.1%
105678	1	< 0.1%
105180	12	0.1%
105139	2	< 0.1%
105074	6	< 0.1%
105040	7	< 0.1%

nm_municipio
Text

Distinct	550
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

Length

Max length	28
Median length	24
Mean length	10.01446
Min length	3

Characters and Unicode

Total characters	166210
Distinct characters	28
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	179 ?
Unique (%)	1.1%

Sample

1st row	BRASILIA
2nd row	BRASILIA
3rd row	FLORIANOPOLIS
4th row	FLORIANOPOLIS
5th row	GAROPABA

Value	Count	Frequency (%)
florianopolis	2918	12.8%
sao	1561	6.8%
joinville	1015	4.4%
do	959	4.2%
jose	782	3.4%
sul	726	3.2%
blumenau	604	2.6%
palhoca	516	2.3%
itajai	468	2.0%
chapeco	435	1.9%
Other values (597)	12848	56.3%

Most occurring characters

Value	Count	Frequency (%)
A	23163	13.9%
O	21671	13.0%
I	17245	10.4%
L	13138	7.9%
R	11373	6.8%
S	9823	5.9%
N	8997	5.4%
E	8115	4.9%
U	6745	4.1%
	6235	3.8%
Other values (18)	39705	23.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	159974	96.2%
Space Separator	6235	3.8%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	23163	14.5%
O	21671	13.5%
I	17245	10.8%
L	13138	8.2%
R	11373	7.1%
S	9823	6.1%
N	8997	5.6%
E	8115	5.1%
U	6745	4.2%
P	5907	3.7%
Other values (16)	33797	21.1%

Space Separator

Value	Count	Frequency (%)
	6235	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	159974	96.2%
Common	6236	3.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	23163	14.5%
O	21671	13.5%
I	17245	10.8%
L	13138	8.2%
R	11373	7.1%
S	9823	6.1%
N	8997	5.6%
E	8115	5.1%
U	6745	4.2%
P	5907	3.7%
Other values (16)	33797	21.1%

Common

Value	Count	Frequency (%)
	6235	> 99.9%
-	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	166176	> 99.9%
None	34	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	23163	13.9%
O	21671	13.0%
I	17245	10.4%
L	13138	7.9%
R	11373	6.8%
S	9823	5.9%
N	8997	5.4%
E	8115	4.9%
U	6745	4.1%
	6235	3.8%
Other values (16)	39671	23.9%

None

Value	Count	Frequency (%)
Á	17	50.0%
Ã	17	50.0%

sg_uf
Categorical

HIGH CORRELATION IMBALANCE

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	129.8 KiB

SC	15230
SP	415
DF	387
PR	189
RS	147
Other values (20)	229

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	33194
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DF
2nd row	DF
3rd row	SC
4th row	SC
5th row	SC

Common Values

Value	Count	Frequency (%)
SC	15230	91.8%
SP	415	2.5%
DF	387	2.3%
PR	189	1.1%
RS	147	0.9%
RJ	62	0.4%
MG	61	0.4%
GO	17	0.1%
SE	16	0.1%
BA	10	0.1%
Other values (15)	63	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sc	15230	91.8%
sp	415	2.5%
df	387	2.3%
pr	189	1.1%
rs	147	0.9%
rj	62	0.4%
mg	61	0.4%
go	17	0.1%
se	16	0.1%
ba	10	0.1%
Other values (15)	63	0.4%

Most occurring characters

Value	Count	Frequency (%)
S	15823	47.7%
C	15236	45.9%
P	623	1.9%
R	402	1.2%
D	387	1.2%
F	387	1.2%
M	80	0.2%
G	78	0.2%
J	62	0.2%
E	32	0.1%
Other values (7)	84	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	33194	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	15823	47.7%
C	15236	45.9%
P	623	1.9%
R	402	1.2%
D	387	1.2%
F	387	1.2%
M	80	0.2%
G	78	0.2%
J	62	0.2%
E	32	0.1%
Other values (7)	84	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33194	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	15823	47.7%
C	15236	45.9%
P	623	1.9%
R	402	1.2%
D	387	1.2%
F	387	1.2%
M	80	0.2%
G	78	0.2%
J	62	0.2%
E	32	0.1%
Other values (7)	84	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33194	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	15823	47.7%
C	15236	45.9%
P	623	1.9%
R	402	1.2%
D	387	1.2%
F	387	1.2%
M	80	0.2%
G	78	0.2%
J	62	0.2%
E	32	0.1%
Other values (7)	84	0.3%

de_bairro
Text

MISSING

Distinct	2938
Distinct (%)	30.5%
Missing	6964
Missing (%)	42.0%
Memory size	129.8 KiB

Length

Max length	50
Median length	46
Mean length	10.098412
Min length	1

Characters and Unicode

Total characters	97278
Distinct characters	98
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1773 ?
Unique (%)	18.4%

Sample

1st row	agronomica
2nd row	Pântano do Sul
3rd row	Santa cecilia
4th row	Campeche
5th row	Santa cecilia

Value	Count	Frequency (%)
centro	1698	10.9%
do	449	2.9%
são	402	2.6%
vila	316	2.0%
nova	268	1.7%
rio	266	1.7%
jardim	239	1.5%
de	203	1.3%
da	193	1.2%
santa	185	1.2%
Other values (1801)	11398	73.0%

Most occurring characters

Value	Count	Frequency (%)
a	11110	11.4%
o	8904	9.2%
r	8347	8.6%
e	7150	7.4%
i	6321	6.5%
	6004	6.2%
n	4940	5.1%
t	4706	4.8%
s	3737	3.8%
d	2608	2.7%
Other values (88)	33451	34.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	73897	76.0%
Uppercase Letter	17037	17.5%
Space Separator	6004	6.2%
Decimal Number	197	0.2%
Other Punctuation	79	0.1%
Dash Punctuation	29	< 0.1%
Close Punctuation	16	< 0.1%
Open Punctuation	14	< 0.1%
Connector Punctuation	3	< 0.1%
Other Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	11110	15.0%
o	8904	12.0%
r	8347	11.3%
e	7150	9.7%
i	6321	8.6%
n	4940	6.7%
t	4706	6.4%
s	3737	5.1%
d	2608	3.5%
l	2513	3.4%
Other values (28)	13561	18.4%

Uppercase Letter

Value	Count	Frequency (%)
C	2501	14.7%
A	1559	9.2%
S	1450	8.5%
R	1259	7.4%
I	1212	7.1%
P	994	5.8%
E	884	5.2%
N	832	4.9%
B	801	4.7%
O	762	4.5%
Other values (26)	4783	28.1%

Decimal Number

Value	Count	Frequency (%)
1	35	17.8%
0	31	15.7%
2	28	14.2%
3	24	12.2%
9	21	10.7%
5	16	8.1%
8	15	7.6%
4	11	5.6%
7	9	4.6%
6	7	3.6%

Other Punctuation

Value	Count	Frequency (%)
.	30	38.0%
,	24	30.4%
/	17	21.5%
'	5	6.3%
:	1	1.3%
?	1	1.3%
&	1	1.3%

Space Separator

Value	Count	Frequency (%)
	6004	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	16	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	14	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3	100.0%

Other Symbol

Value	Count	Frequency (%)
°	1	100.0%

Math Symbol

Value	Count	Frequency (%)
=	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	90934	93.5%
Common	6344	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	11110	12.2%
o	8904	9.8%
r	8347	9.2%
e	7150	7.9%
i	6321	7.0%
n	4940	5.4%
t	4706	5.2%
s	3737	4.1%
d	2608	2.9%
l	2513	2.8%
Other values (64)	30598	33.6%

Common

Value	Count	Frequency (%)
	6004	94.6%
1	35	0.6%
0	31	0.5%
.	30	0.5%
-	29	0.5%
2	28	0.4%
,	24	0.4%
3	24	0.4%
9	21	0.3%
/	17	0.3%
Other values (14)	101	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	95272	97.9%
None	2006	2.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	11110	11.7%
o	8904	9.3%
r	8347	8.8%
e	7150	7.5%
i	6321	6.6%
	6004	6.3%
n	4940	5.2%
t	4706	4.9%
s	3737	3.9%
d	2608	2.7%
Other values (65)	31445	33.0%

None

Value	Count	Frequency (%)
ã	764	38.1%
ç	245	12.2%
á	225	11.2%
ó	182	9.1%
é	122	6.1%
í	79	3.9%
ô	71	3.5%
Á	57	2.8%
ê	51	2.5%
â	48	2.4%
Other values (13)	162	8.1%

de_cep
Text

MISSING

Distinct	5422
Distinct (%)	54.5%
Missing	6653
Missing (%)	40.1%
Memory size	129.8 KiB

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	119328
Distinct characters	55
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3957 ?
Unique (%)	39.8%

Sample

1st row	88067001
2nd row	89540000
3rd row	88063-082
4th row	89540000
5th row	89270000

Value	Count	Frequency (%)
88220000	85	0.9%
89240000	56	0.6%
88115730	53	0.5%
88780000	50	0.5%
88.010-102	50	0.5%
88495000	46	0.5%
88220-000	44	0.4%
89520000	41	0.4%
89249000	39	0.4%
89520-000	38	0.4%
Other values (5420)	9475	95.0%

Most occurring characters

Value	Count	Frequency (%)
	36499	30.6%
0	24331	20.4%
8	18051	15.1%
1	5954	5.0%
9	5787	4.8%
2	5363	4.5%
3	5035	4.2%
5	4925	4.1%
4	3546	3.0%
6	3239	2.7%
Other values (45)	6598	5.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79310	66.5%
Space Separator	36500	30.6%
Dash Punctuation	3063	2.6%
Other Punctuation	331	0.3%
Lowercase Letter	84	0.1%
Uppercase Letter	24	< 0.1%
Connector Punctuation	13	< 0.1%
Control	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	12	14.3%
o	10	11.9%
g	8	9.5%
e	7	8.3%
a	6	7.1%
m	6	7.1%
l	5	6.0%
n	5	6.0%
s	4	4.8%
t	4	4.8%
Other values (11)	17	20.2%

Uppercase Letter

Value	Count	Frequency (%)
N	4	16.7%
C	4	16.7%
A	3	12.5%
I	2	8.3%
J	2	8.3%
S	1	4.2%
T	1	4.2%
E	1	4.2%
R	1	4.2%
O	1	4.2%
Other values (4)	4	16.7%

Decimal Number

Value	Count	Frequency (%)
0	24331	30.7%
8	18051	22.8%
1	5954	7.5%
9	5787	7.3%
2	5363	6.8%
3	5035	6.3%
5	4925	6.2%
4	3546	4.5%
6	3239	4.1%
7	3079	3.9%

Other Punctuation

Value	Count	Frequency (%)
.	323	97.6%
,	5	1.5%
'	2	0.6%
/	1	0.3%

Space Separator

Value	Count	Frequency (%)
	36499	> 99.9%
	1	< 0.1%

Control

Value	Count	Frequency (%)
	2	66.7%
	1	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	3063	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	119220	99.9%
Latin	108	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	12	11.1%
o	10	9.3%
g	8	7.4%
e	7	6.5%
a	6	5.6%
m	6	5.6%
l	5	4.6%
n	5	4.6%
N	4	3.7%
C	4	3.7%
Other values (25)	41	38.0%

Common

Value	Count	Frequency (%)
	36499	30.6%
0	24331	20.4%
8	18051	15.1%
1	5954	5.0%
9	5787	4.9%
2	5363	4.5%
3	5035	4.2%
5	4925	4.1%
4	3546	3.0%
6	3239	2.7%
Other values (10)	6490	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	119321	> 99.9%
None	7	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	36499	30.6%
0	24331	20.4%
8	18051	15.1%
1	5954	5.0%
9	5787	4.8%
2	5363	4.5%
3	5035	4.2%
5	4925	4.1%
4	3546	3.0%
6	3239	2.7%
Other values (40)	6591	5.5%

None

Value	Count	Frequency (%)
ã	3	42.9%
	1	14.3%
ó	1	14.3%
	1	14.3%
ç	1	14.3%

id_municipio_fato_ocorrido
Real number (ℝ)

HIGH CORRELATION

Distinct	289
Distinct (%)	1.7%
Missing	19
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	77185.705

Minimum	75159
Maximum	108353
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	129.8 KiB

Quantile statistics

Minimum	75159
5-th percentile	75400
Q1	76180
median	76511
Q3	77607
95-th percentile	79022
Maximum	108353
Range	33194
Interquartile range (IQR)	1427

Descriptive statistics

Standard deviation	3020.5137
Coefficient of variation (CV)	0.039133071
Kurtosis	72.517259
Mean	77185.705
Median Absolute Deviation (MAD)	616
Skewness	7.9347816
Sum	1.2795846 × 10⁹
Variance	9123502.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
76414	3283	19.8%
77127	1033	6.2%
78700	711	4.3%
75680	637	3.8%
76970	512	3.1%
77755	505	3.0%
76066	450	2.7%
76180	359	2.2%
75493	318	1.9%
77178	301	1.8%
Other values (279)	8469	51.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
75159	31	0.2%
75167	38	0.2%
75175	48	0.3%
75183	158	1.0%
75191	33	0.2%
75213	39	0.2%
75221	27	0.2%
75230	52	0.3%
75272	30	0.2%
75302	13	0.1%

Value	Count	Frequency (%)
108353	54	0.3%
108352	21	0.1%
107077	6	< 0.1%
105180	12	0.1%
105139	2	< 0.1%
105074	11	0.1%
105040	7	< 0.1%
97314	21	0.1%
96261	15	0.1%
96253	3	< 0.1%

mn_municipio_fato
Text

Distinct	289
Distinct (%)	1.7%
Missing	19
Missing (%)	0.1%
Memory size	129.8 KiB

Length

Max length	28
Median length	23
Mean length	10.159247
Min length	3

Characters and Unicode

Total characters	168420
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	0.1%

Sample

1st row	AGRONOMICA
2nd row	AGROLANDIA
3rd row	FLORIANOPOLIS
4th row	FLORIANOPOLIS
5th row	IMBITUBA

Value	Count	Frequency (%)
florianopolis	3283	14.5%
sao	1341	5.9%
joinville	1033	4.5%
do	980	4.3%
jose	751	3.3%
sul	748	3.3%
blumenau	637	2.8%
itajai	512	2.3%
palhoca	505	2.2%
chapeco	489	2.2%
Other values (340)	12434	54.7%

Most occurring characters

Value	Count	Frequency (%)
A	23143	13.7%
O	22588	13.4%
I	17276	10.3%
L	13427	8.0%
R	11546	6.9%
S	9622	5.7%
N	9549	5.7%
E	8057	4.8%
U	6667	4.0%
	6135	3.6%
Other values (17)	40410	24.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	162285	96.4%
Space Separator	6135	3.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	23143	14.3%
O	22588	13.9%
I	17276	10.6%
L	13427	8.3%
R	11546	7.1%
S	9622	5.9%
N	9549	5.9%
E	8057	5.0%
U	6667	4.1%
P	5998	3.7%
Other values (16)	34412	21.2%

Space Separator

Value	Count	Frequency (%)
	6135	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	162285	96.4%
Common	6135	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	23143	14.3%
O	22588	13.9%
I	17276	10.6%
L	13427	8.3%
R	11546	7.1%
S	9622	5.9%
N	9549	5.9%
E	8057	5.0%
U	6667	4.1%
P	5998	3.7%
Other values (16)	34412	21.2%

Common

Value	Count	Frequency (%)
	6135	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	168378	> 99.9%
None	42	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	23143	13.7%
O	22588	13.4%
I	17276	10.3%
L	13427	8.0%
R	11546	6.9%
S	9622	5.7%
N	9549	5.7%
E	8057	4.8%
U	6667	4.0%
	6135	3.6%
Other values (15)	40368	24.0%

None

Value	Count	Frequency (%)
Á	21	50.0%
Ã	21	50.0%

de_outro_local
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	16597
Missing (%)	100.0%
Memory size	129.8 KiB

de_sexo_solicitante
Categorical

HIGH CORRELATION MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	382
Missing (%)	2.3%
Memory size	129.8 KiB

N	7794
M	4218
F	4203

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	16215
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	M
4th row	N
5th row	M

Common Values

Value	Count	Frequency (%)
N	7794	47.0%
M	4218	25.4%
F	4203	25.3%
(Missing)	382	2.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	7794	48.1%
m	4218	26.0%
f	4203	25.9%

Most occurring characters

Value	Count	Frequency (%)
N	7794	48.1%
M	4218	26.0%
F	4203	25.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16215	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	7794	48.1%
M	4218	26.0%
F	4203	25.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16215	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	7794	48.1%
M	4218	26.0%
F	4203	25.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16215	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	7794	48.1%
M	4218	26.0%
F	4203	25.9%

nu_idade_solicitante
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	16597
Missing (%)	100.0%
Memory size	129.8 KiB

de_forma_tratamento
Categorical

HIGH CORRELATION MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	7896
Missing (%)	47.6%
Memory size	129.8 KiB

Sr	3798
Você	2589
Senhora	1869
Senhorita	445

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	130515
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sr
2nd row	Você
3rd row	Senhora
4th row	Você
5th row	Você

Common Values

Value	Count	Frequency (%)
Sr	3798	22.9%
Você	2589	15.6%
Senhora	1869	11.3%
Senhorita	445	2.7%
(Missing)	7896	47.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sr	3798	43.7%
você	2589	29.8%
senhora	1869	21.5%
senhorita	445	5.1%

Most occurring characters

Value	Count	Frequency (%)
	95475	73.2%
S	6112	4.7%
r	6112	4.7%
o	4903	3.8%
V	2589	2.0%
c	2589	2.0%
ê	2589	2.0%
e	2314	1.8%
n	2314	1.8%
h	2314	1.8%
Other values (3)	3204	2.5%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	95475	73.2%
Lowercase Letter	26339	20.2%
Uppercase Letter	8701	6.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	6112	23.2%
o	4903	18.6%
c	2589	9.8%
ê	2589	9.8%
e	2314	8.8%
n	2314	8.8%
h	2314	8.8%
a	2314	8.8%
i	445	1.7%
t	445	1.7%

Uppercase Letter

Value	Count	Frequency (%)
S	6112	70.2%
V	2589	29.8%

Space Separator

Value	Count	Frequency (%)
	95475	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	95475	73.2%
Latin	35040	26.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	6112	17.4%
r	6112	17.4%
o	4903	14.0%
V	2589	7.4%
c	2589	7.4%
ê	2589	7.4%
e	2314	6.6%
n	2314	6.6%
h	2314	6.6%
a	2314	6.6%
Other values (2)	890	2.5%

Common

Value	Count	Frequency (%)
	95475	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	127926	98.0%
None	2589	2.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	95475	74.6%
S	6112	4.8%
r	6112	4.8%
o	4903	3.8%
V	2589	2.0%
c	2589	2.0%
e	2314	1.8%
n	2314	1.8%
h	2314	1.8%
a	2314	1.8%
Other values (2)	890	0.7%

None

Value	Count	Frequency (%)
ê	2589	100.0%

Auto

Heatmap
Table

	nu_atendimento	id_atendimento	id_natureza	id_assunto	id_area	id_municipio	id_municipio_fato_ocorrido	sg_status_atendimento	de_status_atendimento	de_natureza	id_programa	de_programa	de_area	id_tp_identificacao	de_tp_identificacao	id_forma	de_forma	id_priorizacao	de_priorizacao	sg_uf	de_sexo_solicitante	de_forma_tratamento
nu_atendimento	1.000	1.000	-0.084	0.076	-0.053	0.006	0.007	0.292	0.292	0.089	0.072	0.072	0.079	0.069	0.069	0.051	0.051	0.000	0.000	0.036	0.057	0.040
id_atendimento	1.000	1.000	-0.084	0.076	-0.053	0.006	0.007	0.293	0.293	0.089	0.072	0.072	0.079	0.070	0.070	0.050	0.050	0.000	0.000	0.036	0.056	0.040
id_natureza	-0.084	-0.084	1.000	0.045	0.333	-0.008	-0.007	0.015	0.015	1.000	0.177	0.177	0.422	0.124	0.124	0.333	0.333	0.000	0.000	0.315	0.136	0.055
id_assunto	0.076	0.076	0.045	1.000	-0.035	-0.011	-0.031	0.140	0.140	0.137	0.118	0.118	0.337	0.168	0.168	0.129	0.129	0.000	0.000	0.103	0.145	0.056
id_area	-0.053	-0.053	0.333	-0.035	1.000	-0.042	-0.037	0.100	0.100	0.197	0.258	0.258	0.999	0.217	0.217	0.167	0.167	0.012	0.012	0.173	0.213	0.074
id_municipio	0.006	0.006	-0.008	-0.011	-0.042	1.000	0.691	0.021	0.021	0.247	0.056	0.056	0.318	0.119	0.119	0.428	0.428	0.000	0.000	0.763	0.123	0.028
id_municipio_fato_ocorrido	0.007	0.007	-0.007	-0.031	-0.037	0.691	1.000	0.000	0.000	0.019	0.014	0.014	0.103	0.022	0.022	0.000	0.000	0.000	0.000	0.049	0.015	0.024
sg_status_atendimento	0.292	0.293	0.015	0.140	0.100	0.021	0.000	1.000	1.000	0.038	0.042	0.042	0.230	0.038	0.038	0.014	0.014	0.000	0.000	0.000	0.036	0.007
de_status_atendimento	0.292	0.293	0.015	0.140	0.100	0.021	0.000	1.000	1.000	0.038	0.042	0.042	0.230	0.038	0.038	0.014	0.014	0.000	0.000	0.000	0.036	0.007
de_natureza	0.089	0.089	1.000	0.137	0.197	0.247	0.019	0.038	0.038	1.000	0.233	0.233	0.369	0.190	0.190	0.344	0.344	0.000	0.000	0.266	0.213	0.060
id_programa	0.072	0.072	0.177	0.118	0.258	0.056	0.014	0.042	0.042	0.233	1.000	1.000	0.315	0.134	0.134	0.034	0.034	0.000	0.000	0.065	0.115	0.058
de_programa	0.072	0.072	0.177	0.118	0.258	0.056	0.014	0.042	0.042	0.233	1.000	1.000	0.315	0.134	0.134	0.034	0.034	0.000	0.000	0.065	0.115	0.058
de_area	0.079	0.079	0.422	0.337	0.999	0.318	0.103	0.230	0.230	0.369	0.315	0.315	1.000	0.299	0.299	0.515	0.515	0.000	0.000	0.209	0.298	0.109
id_tp_identificacao	0.069	0.070	0.124	0.168	0.217	0.119	0.022	0.038	0.038	0.190	0.134	0.134	0.299	1.000	1.000	0.117	0.117	0.000	0.000	0.133	0.660	0.142
de_tp_identificacao	0.069	0.070	0.124	0.168	0.217	0.119	0.022	0.038	0.038	0.190	0.134	0.134	0.299	1.000	1.000	0.117	0.117	0.000	0.000	0.133	0.660	0.142
id_forma	0.051	0.050	0.333	0.129	0.167	0.428	0.000	0.014	0.014	0.344	0.034	0.034	0.515	0.117	0.117	1.000	1.000	0.000	0.000	0.440	0.089	0.105
de_forma	0.051	0.050	0.333	0.129	0.167	0.428	0.000	0.014	0.014	0.344	0.034	0.034	0.515	0.117	0.117	1.000	1.000	0.000	0.000	0.440	0.089	0.105
id_priorizacao	0.000	0.000	0.000	0.000	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.500	0.000	0.008	0.000
de_priorizacao	0.000	0.000	0.000	0.000	0.012	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.500	1.000	0.000	0.008	0.000
sg_uf	0.036	0.036	0.315	0.103	0.173	0.763	0.049	0.000	0.000	0.266	0.065	0.065	0.209	0.133	0.133	0.440	0.440	0.000	0.000	1.000	0.144	0.046
de_sexo_solicitante	0.057	0.056	0.136	0.145	0.213	0.123	0.015	0.036	0.036	0.213	0.115	0.115	0.298	0.660	0.660	0.089	0.089	0.008	0.008	0.144	1.000	0.516
de_forma_tratamento	0.040	0.040	0.055	0.056	0.074	0.028	0.024	0.007	0.007	0.060	0.058	0.058	0.109	0.142	0.142	0.105	0.105	0.000	0.000	0.046	0.516	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	nu_atendimento	ano_atendimento	id_atendimento	ch_atendimento	sg_status_atendimento	de_status_atendimento	fg_ativo	dt_criacao	dt_entrada	dt_alteracao	dt_prazo	id_orgao	nm_orgao	sg_orgao	nome_familia	status	id_tp_orgao	id_natureza	de_natureza	id_assunto	de_assunto	id_programa	de_programa	id_area	de_area	id_tp_identificacao	de_tp_identificacao	id_forma	de_forma	id_priorizacao	de_priorizacao	id_municipio	nm_municipio	sg_uf	de_bairro	de_cep	id_municipio_fato_ocorrido	mn_municipio_fato	de_outro_local	de_sexo_solicitante	nu_idade_solicitante	de_forma_tratamento
0	1	2023	466499	2023000001	C	Concluido	True	2023-01-01 03:29:01.61489	2023-01-02 09:09:38.0	2023-01-01 03:29:01.61489	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	1449.0	Não Foi Possível Compreender	4.0	Ouvidoria externa	203.0	Não Identificável	1	Anônimo	2	Internet (portal)	5.0	Normal	15890	BRASILIA	DF	None	None	75183.0	AGRONOMICA	NaN	N	NaN	None
1	2	2023	466500	2023000002	C	Concluido	True	2023-01-01 05:18:44.50668	2023-01-02 09:12:26.0	2023-01-01 05:18:44.50668	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	1449.0	Não Foi Possível Compreender	4.0	Ouvidoria externa	203.0	Não Identificável	1	Anônimo	2	Internet (portal)	5.0	Normal	15890	BRASILIA	DF	None	None	75175.0	AGROLANDIA	NaN	N	NaN	None
2	4	2023	466502	2023000004	C	Concluido	True	2023-01-01 13:38:35.075022	2023-01-02 09:13:46.0	2023-01-01 13:38:35.075022	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	1611.0	Manifestação Incompleta (Falta Dados)	5.0	Ouvidoria interna	203.0	Não Identificável	2	Identificado	2	Internet (portal)	5.0	Normal	76414	FLORIANOPOLIS	SC	agronomica	None	76414.0	FLORIANOPOLIS	NaN	M	NaN	Sr
3	5	2023	466503	2023000005	C	Concluido	True	2023-01-01 14:24:08.316825	2023-01-02 09:15:11.0	2023-01-01 14:24:08.316825	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	242.0	Fiscalização ambiental	4.0	Ouvidoria externa	170.0	FATMA	1	Anônimo	2	Internet (portal)	5.0	Normal	76414	FLORIANOPOLIS	SC	Pântano do Sul	88067001	76414.0	FLORIANOPOLIS	NaN	N	NaN	None
4	6	2023	466504	2023000006	C	Concluido	True	2023-01-01 14:50:22.994792	2023-01-02 09:16:57.0	2023-01-01 14:50:22.994792	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	1611.0	Manifestação Incompleta (Falta Dados)	4.0	Ouvidoria externa	155.0	Segurança Pública	2	Identificado	2	Internet (portal)	5.0	Normal	76490	GAROPABA	SC	None	None	76759.0	IMBITUBA	NaN	M	NaN	Você
5	7	2023	466505	2023000007	C	Concluido	True	2023-01-01 17:35:14.021065	2023-01-02 09:19:33.0	2023-01-01 17:35:14.021065	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	117.0	Comportamento do servidor	4.0	Ouvidoria externa	4.0	Educação	1	Anônimo	2	Internet (portal)	5.0	Normal	76970	ITAJAI	SC	None	None	76970.0	ITAJAI	NaN	N	NaN	None
6	8	2023	466506	2023000008	C	Concluido	True	2023-01-01 18:31:10.873301	2023-01-02 09:22:01.0	2023-01-01 18:31:10.873301	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	1611.0	Manifestação Incompleta (Falta Dados)	4.0	Ouvidoria externa	203.0	Não Identificável	1	Anônimo	2	Internet (portal)	5.0	Normal	76201	CURITIBANOS	SC	Santa cecilia	89540000	78450.0	SANTA CECILIA	NaN	N	NaN	None
7	9	2023	466507	2023000009	C	Concluido	True	2023-01-01 18:46:08.83736	2023-01-02 09:28:02.0	2023-01-01 18:46:08.83736	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	555.0	Vazamento de Água	4.0	Ouvidoria externa	30.0	Água e saneamento/CASAN	2	Identificado	2	Internet (portal)	5.0	Normal	76414	FLORIANOPOLIS	SC	Campeche	88063-082	76414.0	FLORIANOPOLIS	NaN	F	NaN	Senhora
8	10	2023	466508	2023000010	C	Concluido	True	2023-01-01 19:23:05.737303	2023-01-02 09:29:48.0	2023-01-01 19:23:05.737303	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	1611.0	Manifestação Incompleta (Falta Dados)	4.0	Ouvidoria externa	203.0	Não Identificável	1	Anônimo	2	Internet (portal)	5.0	Normal	76201	CURITIBANOS	SC	Santa cecilia	89540000	78450.0	SANTA CECILIA	NaN	N	NaN	None
9	11	2023	466509	2023000011	C	Concluido	True	2023-01-01 19:46:50.271392	2023-01-02 09:31:28.0	2023-01-01 19:46:50.271392	2023-01-31	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	393.0	Multas de trânsito	4.0	Ouvidoria externa	126.0	DETRAN	2	Identificado	2	Internet (portal)	5.0	Normal	76600	GUARAMIRIM	SC	Ilha da figueira	89270000	78875.0	SCHROEDER	NaN	M	NaN	Você

	nu_atendimento	ano_atendimento	id_atendimento	ch_atendimento	sg_status_atendimento	de_status_atendimento	fg_ativo	dt_criacao	dt_entrada	dt_alteracao	dt_prazo	id_orgao	nm_orgao	sg_orgao	nome_familia	status	id_tp_orgao	id_natureza	de_natureza	id_assunto	de_assunto	id_programa	de_programa	id_area	de_area	id_tp_identificacao	de_tp_identificacao	id_forma	de_forma	id_priorizacao	de_priorizacao	id_municipio	nm_municipio	sg_uf	de_bairro	de_cep	id_municipio_fato_ocorrido	mn_municipio_fato	de_outro_local	de_sexo_solicitante	nu_idade_solicitante	de_forma_tratamento
16587	18878	2023	485587	2023018261	P	Pendente	True	2023-07-05 21:54:40.721457	None	2023-07-05 21:54:40.721457	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	1	Anônimo	2	Internet (portal)	NaN	None	75817	CACADOR	SC	None	None	75817.0	CACADOR	NaN	None	NaN	None
16588	18879	2023	485588	2023018262	P	Pendente	True	2023-07-05 22:05:29.155974	None	2023-07-05 22:05:29.155974	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	2	Reclamação	NaN	None	NaN	None	NaN	None	2	Identificado	2	Internet (portal)	NaN	None	76970	ITAJAI	SC	Centro	88301240	76970.0	ITAJAI	NaN	M	NaN	Sr
16589	18880	2023	485589	2023018263	P	Pendente	True	2023-07-05 22:09:39.710053	None	2023-07-05 22:09:39.710053	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	1	Anônimo	2	Internet (portal)	NaN	None	77798	PALMITOS	SC	None	None	77798.0	PALMITOS	NaN	None	NaN	None
16590	18881	2023	485590	2023018264	P	Pendente	True	2023-07-05 22:29:47.667348	None	2023-07-05 22:29:47.667348	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	3	Sigiloso	2	Internet (portal)	NaN	None	77771	BRUNOPOLIS	SC	None	None	77771.0	BRUNOPOLIS	NaN	M	NaN	Sr
16591	18882	2023	485591	2023018265	P	Pendente	True	2023-07-05 22:32:22.648808	None	2023-07-05 22:32:22.648808	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	NaN	None	NaN	None	NaN	None	3	Sigiloso	2	Internet (portal)	NaN	None	78093	POUSO REDONDO	SC	None	None	78093.0	POUSO REDONDO	NaN	F	NaN	Senhorita
16592	18883	2023	485592	2023018266	P	Pendente	True	2023-07-05 22:33:47.286463	None	2023-07-05 22:33:47.286463	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	1	Anônimo	2	Internet (portal)	NaN	None	77127	JOINVILLE	SC	João costa	89209472	77127.0	JOINVILLE	NaN	N	NaN	Sr
16593	18884	2023	485593	2023018267	P	Pendente	True	2023-07-05 22:50:19.63995	None	2023-07-05 22:50:19.63995	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	3	Sigiloso	2	Internet (portal)	NaN	None	77089	JAGUARUNA	SC	None	None	79090.0	TUBARAO	NaN	M	NaN	Você
16594	18885	2023	485594	2023018268	P	Pendente	True	2023-07-05 23:03:39.961797	None	2023-07-05 23:03:39.961797	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	1	Denúncia	NaN	None	NaN	None	NaN	None	1	Anônimo	2	Internet (portal)	NaN	None	75680	BLUMENAU	SC	Vorstadt	89015252	75680.0	BLUMENAU	NaN	None	NaN	None
16595	18886	2023	485595	2023018269	P	Pendente	True	2023-07-05 23:26:01.697794	None	2023-07-05 23:26:01.697794	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	NaN	None	NaN	None	NaN	None	3	Sigiloso	2	Internet (portal)	NaN	None	75680	BLUMENAU	SC	Fortaleza	89057-300	75680.0	BLUMENAU	NaN	F	NaN	Sr
16596	18887	2023	485596	2023018270	P	Pendente	True	2023-07-05 23:29:08.4676	None	2023-07-05 23:29:08.4676	2023-08-04	2	Ouvidoria Geral do Estado	OGE	SC::Ouvidoria Geral do Estado - OGE	A	9	3	Solicitação	NaN	None	NaN	None	NaN	None	2	Identificado	2	Internet (portal)	NaN	None	77755	PALHOCA	SC	Ponte do Imaruim	88130510	76414.0	FLORIANOPOLIS	NaN	M	NaN	Sr

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin